<?php
/*******************************************************************************

    FinalsClub.org is a platform for students and faculty to collaborate
    and share their knowledge with the world.

    Copyright (C) 2009  Andrew Magliozzi
 
    This file is a part of FinalsClub.org.

    FinalsClub.org is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.
 
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.
 
    You should have received a copy of the GNU General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.
 
    To contact FinalsClub.org, send an email to info@finalsclub.org, or
    send mail to Finals Club, c/o Veritas Tutors, 1132 Massachusetts Avenue,
    Cambridge, MA 02138.

*******************************************************************************/
/**
 * CommentPeer.php
 *
 * @package    FinalsClub
 * @subpackage comments
 * @author     Colin Hom
 */

class CommentPeer extends BaseCommentPeer
{
	/*
	@param $type ("Note", "Reading", etc)
	@param $type_id
	@param $maxPerPage
	*/
	public static function retrieveByMaterialIdPager($type,$type_id, $maxPerPage = 5){
		$q = new Criteria();
		$q->add($q->getNewCriterion(CommentPeer::TYPE, $type, Criteria::EQUAL));
		$q->add($q->getNewCriterion(CommentPeer::TYPE_ID, $type_id, Criteria::EQUAL));
		$q->addDescendingOrderByColumn(CommentPeer::CREATED_AT);
		$comment_pager = new sfPropelPager('Comment', $maxPerPage);
		$comment_pager->setCriteria($q);
		return $comment_pager;
	}
	
	public static function retrieveByUserIdPager($uid, $maxPerPage = 5){
		$q = new Criteria();
		$q->add($q->getNewCriterion(CommentPeer::USER_ID, $uid, Criteria::EQUAL));
		$q->addDescendingOrderByColumn(CommentPeer::CREATED_AT);
		$comment_pager = new sfPropelPager('Comment', $maxPerPage);
		$comment_pager->setCriteria($q);
		return $comment_pager;
 		
	}
	  
}
